import matplotlib.pyplot as plt
from excel.service.data import excel_data
# 用Matplotlib画条形图
plt.rcParams['font.family']=['FangSong']
e = excel_data().load("灵璧二中冬季运动会跳绳成绩表.xlsx").read(start=2)
x,y = e.col("姓名"),e.col("个数")
plt.title("灵璧二中冬季运动会跳绳成绩图")
plt.bar(x, y)
plt.show()
